﻿CREATE TABLE [dbo].[List] (
    [ListID]              UNIQUEIDENTIFIER NOT NULL,
    [WebID]               UNIQUEIDENTIFIER NOT NULL,
    [RootFolder]          VARCHAR (50)     NULL,
    [IsSiteAssetsLibrary] BIT              NULL,
    [BaseType]            VARCHAR (50)     NULL,
    [Version]             INT              NULL,
    [ItemCount]           INT              NULL,
    [isDocumentLibrary]   BIT              NULL,
    [Title]               VARCHAR (100)    NULL,
    [Size]                FLOAT (53)       NULL,
    [URL]                 VARCHAR (100)    NULL,
    CONSTRAINT [PK_List] PRIMARY KEY CLUSTERED ([ListID] ASC),
    CONSTRAINT [FK_List_Web] FOREIGN KEY ([WebID]) REFERENCES [dbo].[Web] ([WebID])
);

